[ROOT] dt FactResellerSale < WHERE DimResellerId EQ '270' >
71 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50278_1 | 5267-4442-A3 | PO12006165157 | 100 | 283 | 435 | 270 | 2 | 2023-08-27 | 324.45 | 8.11 | 2023-08-15 | 1 | 300.12 | 1 | 324.45 | 1 | SO50278 | 2023-08-22 | 25.96 | 300.12 | 324.45 |
SO43876_1 | 1E6F-4150-A3 | PO12006119347 | 100 | 281 | 326 | 270 | 2 | 2021-11-27 | 838.92 | 20.97 | 2021-11-15 | 2 | 413.15 | 1 | 838.92 | 1 | SO43876 | 2021-11-22 | 67.11 | 826.29 | 419.46 |
SO43876_2 | 1E6F-4150-A3 | PO12006119347 | 100 | 281 | 319 | 270 | 2 | 2021-11-27 | 874.79 | 21.87 | 2021-11-15 | 1 | 884.71 | 1 | 874.79 | 2 | SO43876 | 2021-11-22 | 69.98 | 884.71 | 874.79 |
SO43876_3 | 1E6F-4150-A3 | PO12006119347 | 100 | 281 | 328 | 270 | 2 | 2021-11-27 | 1258.38 | 31.46 | 2021-11-15 | 3 | 413.15 | 1 | 1258.38 | 3 | SO43876 | 2021-11-22 | 100.67 | 1239.44 | 419.46 |
SO43876_4 | 1E6F-4150-A3 | PO12006119347 | 100 | 281 | 315 | 270 | 2 | 2021-11-27 | 1749.59 | 43.74 | 2021-11-15 | 2 | 884.71 | 1 | 1749.59 | 4 | SO43876 | 2021-11-22 | 139.97 | 1769.42 | 874.79 |
SO43876_5 | 1E6F-4150-A3 | PO12006119347 | 100 | 281 | 262 | 270 | 2 | 2021-11-27 | 367.88 | 9.20 | 2021-11-15 | 2 | 181.49 | 1 | 367.88 | 5 | SO43876 | 2021-11-22 | 29.43 | 362.97 | 183.94 |
SO43876_6 | 1E6F-4150-A3 | PO12006119347 | 100 | 281 | 324 | 270 | 2 | 2021-11-27 | 838.92 | 20.97 | 2021-11-15 | 2 | 413.15 | 1 | 838.92 | 6 | SO43876 | 2021-11-22 | 67.11 | 826.29 | 419.46 |
SO43876_7 | 1E6F-4150-A3 | PO12006119347 | 100 | 281 | 342 | 270 | 2 | 2021-11-27 | 838.92 | 20.97 | 2021-11-15 | 2 | 413.15 | 1 | 838.92 | 7 | SO43876 | 2021-11-22 | 67.11 | 826.29 | 419.46 |
SO43876_8 | 1E6F-4150-A3 | PO12006119347 | 100 | 281 | 270 | 270 | 2 | 2021-11-27 | 367.88 | 9.20 | 2021-11-15 | 2 | 181.49 | 1 | 367.88 | 8 | SO43876 | 2021-11-22 | 29.43 | 362.97 | 183.94 |
SO44522_1 | B9A9-4D27-B7 | PO12006113976 | 100 | 281 | 336 | 270 | 2 | 2022-02-27 | 838.92 | 20.97 | 2022-02-15 | 2 | 413.15 | 1 | 838.92 | 1 | SO44522 | 2022-02-22 | 67.11 | 826.29 | 419.46 |
SO44522_2 | B9A9-4D27-B7 | PO12006113976 | 100 | 281 | 262 | 270 | 2 | 2022-02-27 | 183.94 | 4.60 | 2022-02-15 | 1 | 181.49 | 1 | 183.94 | 2 | SO44522 | 2022-02-22 | 14.72 | 181.49 | 183.94 |
SO44522_3 | B9A9-4D27-B7 | PO12006113976 | 100 | 281 | 270 | 270 | 2 | 2022-02-27 | 183.94 | 4.60 | 2022-02-15 | 1 | 181.49 | 1 | 183.94 | 3 | SO44522 | 2022-02-22 | 14.72 | 181.49 | 183.94 |
SO44522_4 | B9A9-4D27-B7 | PO12006113976 | 100 | 281 | 264 | 270 | 2 | 2022-02-27 | 183.94 | 4.60 | 2022-02-15 | 1 | 181.49 | 1 | 183.94 | 4 | SO44522 | 2022-02-22 | 14.72 | 181.49 | 183.94 |
SO44522_5 | B9A9-4D27-B7 | PO12006113976 | 100 | 281 | 322 | 270 | 2 | 2022-02-27 | 419.46 | 10.49 | 2022-02-15 | 1 | 413.15 | 1 | 419.46 | 5 | SO44522 | 2022-02-22 | 33.56 | 413.15 | 419.46 |
SO44522_6 | B9A9-4D27-B7 | PO12006113976 | 100 | 281 | 340 | 270 | 2 | 2022-02-27 | 419.46 | 10.49 | 2022-02-15 | 1 | 413.15 | 1 | 419.46 | 6 | SO44522 | 2022-02-22 | 33.56 | 413.15 | 419.46 |
SO44522_7 | B9A9-4D27-B7 | PO12006113976 | 100 | 281 | 311 | 270 | 2 | 2022-02-27 | 2146.96 | 53.67 | 2022-02-15 | 1 | 2171.29 | 1 | 2146.96 | 7 | SO44522 | 2022-02-22 | 171.76 | 2171.29 | 2146.96 |
SO44522_8 | B9A9-4D27-B7 | PO12006113976 | 100 | 281 | 313 | 270 | 2 | 2022-02-27 | 8587.85 | 214.70 | 2022-02-15 | 4 | 2171.29 | 1 | 8587.85 | 8 | SO44522 | 2022-02-22 | 687.03 | 8685.18 | 2146.96 |
SO44522_9 | B9A9-4D27-B7 | PO12006113976 | 100 | 281 | 324 | 270 | 2 | 2022-02-27 | 419.46 | 10.49 | 2022-02-15 | 1 | 413.15 | 1 | 419.46 | 9 | SO44522 | 2022-02-22 | 33.56 | 413.15 | 419.46 |
SO44522_10 | B9A9-4D27-B7 | PO12006113976 | 100 | 281 | 310 | 270 | 2 | 2022-02-27 | 2146.96 | 53.67 | 2022-02-15 | 1 | 2171.29 | 1 | 2146.96 | 10 | SO44522 | 2022-02-22 | 171.76 | 2171.29 | 2146.96 |
SO44522_11 | B9A9-4D27-B7 | PO12006113976 | 100 | 281 | 326 | 270 | 2 | 2022-02-27 | 419.46 | 10.49 | 2022-02-15 | 1 | 413.15 | 1 | 419.46 | 11 | SO44522 | 2022-02-22 | 33.56 | 413.15 | 419.46 |
SO44522_12 | B9A9-4D27-B7 | PO12006113976 | 100 | 281 | 272 | 270 | 2 | 2022-02-27 | 183.94 | 4.60 | 2022-02-15 | 1 | 181.49 | 1 | 183.94 | 12 | SO44522 | 2022-02-22 | 14.72 | 181.49 | 183.94 |
SO44522_13 | B9A9-4D27-B7 | PO12006113976 | 100 | 281 | 334 | 270 | 2 | 2022-02-27 | 419.46 | 10.49 | 2022-02-15 | 1 | 413.15 | 1 | 419.46 | 13 | SO44522 | 2022-02-22 | 33.56 | 413.15 | 419.46 |
SO44522_14 | B9A9-4D27-B7 | PO12006113976 | 100 | 281 | 317 | 270 | 2 | 2022-02-27 | 874.79 | 21.87 | 2022-02-15 | 1 | 884.71 | 1 | 874.79 | 14 | SO44522 | 2022-02-22 | 69.98 | 884.71 | 874.79 |
SO44522_15 | B9A9-4D27-B7 | PO12006113976 | 100 | 281 | 342 | 270 | 2 | 2022-02-27 | 838.92 | 20.97 | 2022-02-15 | 2 | 413.15 | 1 | 838.92 | 15 | SO44522 | 2022-02-22 | 67.11 | 826.29 | 419.46 |
SO44522_16 | B9A9-4D27-B7 | PO12006113976 | 100 | 281 | 285 | 270 | 2 | 2022-02-27 | 357.16 | 8.93 | 2022-02-15 | 2 | 176.20 | 1 | 357.16 | 16 | SO44522 | 2022-02-22 | 28.57 | 352.40 | 178.58 |
SO44522_17 | B9A9-4D27-B7 | PO12006113976 | 100 | 281 | 315 | 270 | 2 | 2022-02-27 | 2624.38 | 65.61 | 2022-02-15 | 3 | 884.71 | 1 | 2624.38 | 17 | SO44522 | 2022-02-22 | 209.95 | 2654.12 | 874.79 |
SO44522_18 | B9A9-4D27-B7 | PO12006113976 | 100 | 281 | 318 | 270 | 2 | 2022-02-27 | 874.79 | 21.87 | 2022-02-15 | 1 | 884.71 | 1 | 874.79 | 18 | SO44522 | 2022-02-22 | 69.98 | 884.71 | 874.79 |
SO44522_19 | B9A9-4D27-B7 | PO12006113976 | 100 | 281 | 253 | 270 | 2 | 2022-02-27 | 178.58 | 4.46 | 2022-02-15 | 1 | 176.20 | 1 | 178.58 | 19 | SO44522 | 2022-02-22 | 14.29 | 176.20 | 178.58 |
SO44522_20 | B9A9-4D27-B7 | PO12006113976 | 100 | 281 | 319 | 270 | 2 | 2022-02-27 | 1749.59 | 43.74 | 2022-02-15 | 2 | 884.71 | 1 | 1749.59 | 20 | SO44522 | 2022-02-22 | 139.97 | 1769.42 | 874.79 |
SO44522_21 | B9A9-4D27-B7 | PO12006113976 | 100 | 281 | 332 | 270 | 2 | 2022-02-27 | 419.46 | 10.49 | 2022-02-15 | 1 | 413.15 | 1 | 419.46 | 21 | SO44522 | 2022-02-22 | 33.56 | 413.15 | 419.46 |
SO44522_22 | B9A9-4D27-B7 | PO12006113976 | 100 | 281 | 338 | 270 | 2 | 2022-02-27 | 1677.84 | 41.95 | 2022-02-15 | 4 | 413.15 | 1 | 1677.84 | 22 | SO44522 | 2022-02-22 | 134.23 | 1652.59 | 419.46 |
SO45302_1 | 485F-48BA-86 | PO12006146340 | 100 | 281 | 317 | 270 | 2 | 2022-05-30 | 1749.59 | 43.74 | 2022-05-18 | 2 | 884.71 | 1 | 1749.59 | 1 | SO45302 | 2022-05-25 | 139.97 | 1769.42 | 874.79 |
SO45302_2 | 485F-48BA-86 | PO12006146340 | 100 | 281 | 314 | 270 | 2 | 2022-05-30 | 4293.92 | 107.35 | 2022-05-18 | 2 | 2171.29 | 1 | 4293.92 | 2 | SO45302 | 2022-05-25 | 343.51 | 4342.59 | 2146.96 |
SO45302_3 | 485F-48BA-86 | PO12006146340 | 100 | 281 | 322 | 270 | 2 | 2022-05-30 | 838.92 | 20.97 | 2022-05-18 | 2 | 413.15 | 1 | 838.92 | 3 | SO45302 | 2022-05-25 | 67.11 | 826.29 | 419.46 |
SO45302_4 | 485F-48BA-86 | PO12006146340 | 100 | 281 | 334 | 270 | 2 | 2022-05-30 | 1258.38 | 31.46 | 2022-05-18 | 3 | 413.15 | 1 | 1258.38 | 4 | SO45302 | 2022-05-25 | 100.67 | 1239.44 | 419.46 |
SO45302_5 | 485F-48BA-86 | PO12006146340 | 100 | 281 | 328 | 270 | 2 | 2022-05-30 | 838.92 | 20.97 | 2022-05-18 | 2 | 413.15 | 1 | 838.92 | 5 | SO45302 | 2022-05-25 | 67.11 | 826.29 | 419.46 |
SO45302_6 | 485F-48BA-86 | PO12006146340 | 100 | 281 | 313 | 270 | 2 | 2022-05-30 | 4293.92 | 107.35 | 2022-05-18 | 2 | 2171.29 | 1 | 4293.92 | 6 | SO45302 | 2022-05-25 | 343.51 | 4342.59 | 2146.96 |
SO45302_7 | 485F-48BA-86 | PO12006146340 | 100 | 281 | 332 | 270 | 2 | 2022-05-30 | 419.46 | 10.49 | 2022-05-18 | 1 | 413.15 | 1 | 419.46 | 7 | SO45302 | 2022-05-25 | 33.56 | 413.15 | 419.46 |
SO45302_8 | 485F-48BA-86 | PO12006146340 | 100 | 281 | 336 | 270 | 2 | 2022-05-30 | 419.46 | 10.49 | 2022-05-18 | 1 | 413.15 | 1 | 419.46 | 8 | SO45302 | 2022-05-25 | 33.56 | 413.15 | 419.46 |
SO45302_9 | 485F-48BA-86 | PO12006146340 | 100 | 281 | 342 | 270 | 2 | 2022-05-30 | 838.92 | 20.97 | 2022-05-18 | 2 | 413.15 | 1 | 838.92 | 9 | SO45302 | 2022-05-25 | 67.11 | 826.29 | 419.46 |
SO45302_10 | 485F-48BA-86 | PO12006146340 | 100 | 281 | 326 | 270 | 2 | 2022-05-30 | 419.46 | 10.49 | 2022-05-18 | 1 | 413.15 | 1 | 419.46 | 10 | SO45302 | 2022-05-25 | 33.56 | 413.15 | 419.46 |
SO45302_11 | 485F-48BA-86 | PO12006146340 | 100 | 281 | 330 | 270 | 2 | 2022-05-30 | 419.46 | 10.49 | 2022-05-18 | 1 | 413.15 | 1 | 419.46 | 11 | SO45302 | 2022-05-25 | 33.56 | 413.15 | 419.46 |
SO45302_12 | 485F-48BA-86 | PO12006146340 | 100 | 281 | 340 | 270 | 2 | 2022-05-30 | 419.46 | 10.49 | 2022-05-18 | 1 | 413.15 | 1 | 419.46 | 12 | SO45302 | 2022-05-25 | 33.56 | 413.15 | 419.46 |
SO45302_13 | 485F-48BA-86 | PO12006146340 | 100 | 281 | 312 | 270 | 2 | 2022-05-30 | 4293.92 | 107.35 | 2022-05-18 | 2 | 2171.29 | 1 | 4293.92 | 13 | SO45302 | 2022-05-25 | 343.51 | 4342.59 | 2146.96 |
SO45302_14 | 485F-48BA-86 | PO12006146340 | 100 | 281 | 320 | 270 | 2 | 2022-05-30 | 838.92 | 20.97 | 2022-05-18 | 2 | 413.15 | 1 | 838.92 | 14 | SO45302 | 2022-05-25 | 67.11 | 826.29 | 419.46 |
SO45302_15 | 485F-48BA-86 | PO12006146340 | 100 | 281 | 315 | 270 | 2 | 2022-05-30 | 874.79 | 21.87 | 2022-05-18 | 1 | 884.71 | 1 | 874.79 | 15 | SO45302 | 2022-05-25 | 69.98 | 884.71 | 874.79 |
SO46059_1 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 312 | 270 | 2 | 2022-08-27 | 4293.92 | 107.35 | 2022-08-15 | 2 | 2171.29 | 1 | 4293.92 | 1 | SO46059 | 2022-08-22 | 343.51 | 4342.59 | 2146.96 |
SO46059_2 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 310 | 270 | 2 | 2022-08-27 | 2146.96 | 53.67 | 2022-08-15 | 1 | 2171.29 | 1 | 2146.96 | 2 | SO46059 | 2022-08-22 | 171.76 | 2171.29 | 2146.96 |
SO46059_3 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 336 | 270 | 2 | 2022-08-27 | 838.92 | 20.97 | 2022-08-15 | 2 | 413.15 | 1 | 838.92 | 3 | SO46059 | 2022-08-22 | 67.11 | 826.29 | 419.46 |
SO46059_4 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 330 | 270 | 2 | 2022-08-27 | 419.46 | 10.49 | 2022-08-15 | 1 | 413.15 | 1 | 419.46 | 4 | SO46059 | 2022-08-22 | 33.56 | 413.15 | 419.46 |
SO46059_5 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 340 | 270 | 2 | 2022-08-27 | 419.46 | 10.49 | 2022-08-15 | 1 | 413.15 | 1 | 419.46 | 5 | SO46059 | 2022-08-22 | 33.56 | 413.15 | 419.46 |
SO46059_6 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 264 | 270 | 2 | 2022-08-27 | 183.94 | 4.60 | 2022-08-15 | 1 | 181.49 | 1 | 183.94 | 6 | SO46059 | 2022-08-22 | 14.72 | 181.49 | 183.94 |
SO46059_7 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 338 | 270 | 2 | 2022-08-27 | 419.46 | 10.49 | 2022-08-15 | 1 | 413.15 | 1 | 419.46 | 7 | SO46059 | 2022-08-22 | 33.56 | 413.15 | 419.46 |
SO46059_8 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 318 | 270 | 2 | 2022-08-27 | 2624.38 | 65.61 | 2022-08-15 | 3 | 884.71 | 1 | 2624.38 | 8 | SO46059 | 2022-08-22 | 209.95 | 2654.12 | 874.79 |
SO46059_9 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 262 | 270 | 2 | 2022-08-27 | 183.94 | 4.60 | 2022-08-15 | 1 | 181.49 | 1 | 183.94 | 9 | SO46059 | 2022-08-22 | 14.72 | 181.49 | 183.94 |
SO46059_10 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 311 | 270 | 2 | 2022-08-27 | 4293.92 | 107.35 | 2022-08-15 | 2 | 2171.29 | 1 | 4293.92 | 10 | SO46059 | 2022-08-22 | 343.51 | 4342.59 | 2146.96 |
SO46059_11 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 328 | 270 | 2 | 2022-08-27 | 419.46 | 10.49 | 2022-08-15 | 1 | 413.15 | 1 | 419.46 | 11 | SO46059 | 2022-08-22 | 33.56 | 413.15 | 419.46 |
SO46059_12 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 315 | 270 | 2 | 2022-08-27 | 2624.38 | 65.61 | 2022-08-15 | 3 | 884.71 | 1 | 2624.38 | 12 | SO46059 | 2022-08-22 | 209.95 | 2654.12 | 874.79 |
SO46059_13 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 326 | 270 | 2 | 2022-08-27 | 419.46 | 10.49 | 2022-08-15 | 1 | 413.15 | 1 | 419.46 | 13 | SO46059 | 2022-08-22 | 33.56 | 413.15 | 419.46 |
SO46059_14 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 285 | 270 | 2 | 2022-08-27 | 178.58 | 4.46 | 2022-08-15 | 1 | 176.20 | 1 | 178.58 | 14 | SO46059 | 2022-08-22 | 14.29 | 176.20 | 178.58 |
SO46059_15 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 270 | 270 | 2 | 2022-08-27 | 183.94 | 4.60 | 2022-08-15 | 1 | 181.49 | 1 | 183.94 | 15 | SO46059 | 2022-08-22 | 14.72 | 181.49 | 183.94 |
SO46059_16 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 322 | 270 | 2 | 2022-08-27 | 1258.38 | 31.46 | 2022-08-15 | 3 | 413.15 | 1 | 1258.38 | 16 | SO46059 | 2022-08-22 | 100.67 | 1239.44 | 419.46 |
SO46059_17 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 324 | 270 | 2 | 2022-08-27 | 419.46 | 10.49 | 2022-08-15 | 1 | 413.15 | 1 | 419.46 | 17 | SO46059 | 2022-08-22 | 33.56 | 413.15 | 419.46 |
SO46059_18 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 313 | 270 | 2 | 2022-08-27 | 6440.89 | 161.02 | 2022-08-15 | 3 | 2171.29 | 1 | 6440.89 | 18 | SO46059 | 2022-08-22 | 515.27 | 6513.88 | 2146.96 |
SO46059_19 | ECBE-4E0D-B9 | PO12006169607 | 100 | 281 | 332 | 270 | 2 | 2022-08-27 | 1677.84 | 41.95 | 2022-08-15 | 4 | 413.15 | 1 | 1677.84 | 19 | SO46059 | 2022-08-22 | 134.23 | 1652.59 | 419.46 |
SO69438_1 | FC2A-4BFB-98 | PO12006131752 | 100 | 283 | 408 | 270 | 2 | 2024-08-27 | 72.16 | 1.80 | 2024-08-15 | 1 | 53.40 | 1 | 72.16 | 1 | SO69438 | 2024-08-22 | 5.77 | 53.40 | 72.16 |
SO51743_1 | 4DE3-4586-96 | PO12006129958 | 100 | 283 | 240 | 270 | 2 | 2023-11-27 | 858.90 | 21.47 | 2023-11-15 | 1 | 868.63 | 1 | 858.90 | 1 | SO51743 | 2023-11-22 | 68.71 | 868.63 | 858.90 |
SO51743_2 | 4DE3-4586-96 | PO12006129958 | 100 | 283 | 520 | 270 | 2 | 2023-11-27 | 94.75 | 2.37 | 2023-11-15 | 3 | 23.37 | 1 | 94.75 | 2 | SO51743 | 2023-11-22 | 7.58 | 70.12 | 31.58 |
SO51743_3 | 4DE3-4586-96 | PO12006129958 | 100 | 283 | 243 | 270 | 2 | 2023-11-27 | 1717.80 | 42.95 | 2023-11-15 | 2 | 868.63 | 1 | 1717.80 | 3 | SO51743 | 2023-11-22 | 137.42 | 1737.27 | 858.90 |
SO51743_4 | 4DE3-4586-96 | PO12006129958 | 100 | 283 | 404 | 270 | 2 | 2023-11-27 | 26.72 | 0.67 | 2023-11-15 | 1 | 19.78 | 1 | 26.72 | 4 | SO51743 | 2023-11-22 | 2.14 | 19.78 | 26.72 |
SO57114_1 | 626A-466A-98 | PO12006142752 | 100 | 283 | 287 | 270 | 2 | 2024-02-27 | 202.33 | 5.06 | 2024-02-15 | 1 | 204.63 | 1 | 202.33 | 1 | SO57114 | 2024-02-22 | 16.19 | 204.63 | 202.33 |
Generated 2024-11-14 16:45:32.074 UTC